Access 97

Okay. I am trying to pull data back from two tables.
One table Order_info has 64,491 records and the second table OrderStatus has 9,489 records.
sql:
SELECT WOT_OrderStatusInfo.[WOT Order Tool Number], Order_info_from_01012001.[WOT Order Tool Number]
FROM Order_info_from_01012001 LEFT JOIN WOT_OrderStatusInfo ON Order_info_from_01012001.[WOT Order Tool Number] = WOT_OrderStatusInfo.[WOT Order Tool Number]
GROUP BY WOT_OrderStatusInfo.[WOT Order Tool Number], Order_info_from_01012001.[WOT Order Tool Number];

It's not giving me all the data from the second table only where the data is alike.
Help

 

let me if I understand you.
You want data from table A and Table be to be directly related and only show the data that is equal from both tables?

or do you want all data from table A and data from Table B that is equal.

 

Table A and Table B contain different data. Table A has a list of numbers is a column. Table B has the same column of data but the entrys are completly different. If we can combine the two and get a list of ALL of the data thats what we want. Table A has some data and table B has the rest, she wants to combine them,


I hope I didnt just confuse the hell out of you Kodosan

 

the answer is a UNION query.

do two select queries. .one for table A and one for Table B..
next make a UNION query and copy the SQL code for the first two queries into it such it looks like this

SQL1

UNION ALL

SQL2


where SQL1 and 2 are the queries SQL code for the first 2 queries.

 

Access

I should have know. I told Glenn that.
Thanks for your help.