But you cannot specify a list of tables in the repository.xml file.
The best that you can do in the XML file is to write a subquery or use a bunch of left joins.
And the left join syntax cannot be used with all databases...like Oracle.
Antonio Gallardo wrote:
On Vie, 21 de Enero de 2005, 14:48, Bobby Lawrence dijo:
SELECT <column> FROM (SELECT * FROM <table>) vs. SELECT * FROM <table> WHERE <column> IN (SELECT <column> FROM <table> WHERE <column> = 'aValue')
If so, the table alias would still not be needed because the columns are
still only coming from one table....
Not in all cases. Is posible to write:
SELECT * FROM <table_list> WHERE <column> IN ( SELECT <column> FROM <table_list> WHERE <column> = 'aValue' )
Best Regards,
Antonio Gallardo
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- ---------------------------- Bobby Lawrence MIS Application Developer
Jefferson Lab (www.jlab.org)
Email: [EMAIL PROTECTED] Office: (757) 269-5818 Pager: (757) 584-5818 ----------------------------
