Sounds like you want a union query... SELECT something, something_else FROM table1 UNION SELECT something, something_else FROM table2 I think some databases are pickier than others about each pair of fields being of the same datatype; Oracle requires each field to return the same number of fields, while I seem to recall MS Jet doesn't... For mismatched numbers of columns, do something like: SELECT something, '' FROM table1 UNION SELECT something, something_else FROM table2 If it's fussy about datatypes, using '', 0, null, sysdate, to_char() or similar things to match the datatypes of the corresponding fields should keep it happy... hth Rufus. -----Original Message----- From: bari [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 10:57 PM To: [EMAIL PROTECTED] Subject: Simple question about tables Hi there, I have two query's both have same # or rows as out put but have different columns. Like the first query gives me like 4 columns and the second query gives me 1 column as out put.. Now I want to club the results of both the queries so that the resulting table is 5 rows. I am able to display the result of each query in separate table.. Like I am able to display the result of first query which is 4 columns in one table. and the result of second query with one column as separate table. but I am not able to add the an extra column to first query so that it gives me an option to display result of the second query. it would be great if any one can help me. Thank You -bari --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
