Access SQL Query Error

[new_to_sql]

Hi all,

Thanks in advance for your help. I have two queries that have a common field but the columns are not the same other than the common field. I need data from both queries if query A and query B common field "ID" are the same. Note query B has more data than query A. I want to pull in data from both queries if query A "ID" is found/matched in query B. I tried the below but I keep getting syntax error. I tried using query wizard and join "ID" field but access hangs and crashes or only shows me data from one of the queries

Select * FROM [Query A] INTERSECT [Query B]
Where[Query A].[ID] =[Query By].[ID];

Not sure what I am doing wrong, but if you can help guide me to right solution that would be greatly appreciated.

Thank you in advance for your help.

 

[Mike Lewis]

Select * FROM [Query A] INTERSECT [Query B]
Where[Query A].[ID] =[Query [highlight #FCE94F]By[/highlight]].[ID];

Can we assume that [tt]Query By[/tt] is a typing error, and you actually meant [tt]Query B[/tt]?

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[new_to_sql]

Hi Mike,

Yes that is a typing error and is meant to be query B.

 

[Andrzejek]

>I want to pull in data from both queries if query A "ID" is found/matched in query B.
An old fashioned way would be:

[pre]
Select A.*, B.*
From [Query A] A, [Query B] B
Where A.ID = B.ID[/pre]

And since you said: "access hangs and crashes", you may get better response in any of the Access forums.
This is an SQL Server forum.

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[new_to_sql]

Thanks Andy - appreciate the help and will take it to Access Forum. Thank you again for your help

 

[dhookom]

If the tables/data is on SQL server you should consider creating a view on SQL Server or use a pass-through query in MS Access.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016