can query link with another table??

  • Thread starter Thread starter az
  • Start date Start date
A

az

hola..
i have make a query for a table in my database..but..i need to add
field from another table to that query..can i???can anyone help me???
 
az said:
hola..
i have make a query for a table in my database..but..i need to add
field from another table to that query..can i???can anyone help me???
Click to expand...

A definite maybe. You realize how little information this is, right?
Do the two tables have a field in common? Could you post the SQL?
Can't speak for anyone else here, but my clairvoyant skills just aren't
what they used to be. And shouldn't this be in the queries group?
 
In query design view:

1) add the second table
2) join the two tables as required
3) drag the field from the second table into the query grid.

See Help for more, e.g. the topic "About designing a query"
 
Back
Top