what difference between table relationship and query relationship

**deepaksharma** · 08-21-2023, 12:37 AM

what is the difference between table relation and query relation ?

**CJ_London** · 08-21-2023, 01:14 AM

Queries don’t have relationships, they have joins. Joins and relationships use much the same presentation style of using a line

**orange** · 08-21-2023, 05:45 AM

See this post by Pat Hartman where she discusses Joins and Relationships.

**deepaksharma** · 08-24-2023, 01:33 AM

can you please explain me major difference in only 1 line?

**CJ_London** · 08-24-2023, 03:10 AM

can you please explain me major difference in only 1 line?

see post #2

you can add to it - Relationships are permanent, joins only exist in queries

so now you have in one line

Queries don’t have relationships, they have joins. Joins and relationships use much the same presentation style of using a line. Relationships are permanent, joins only exist in queries

If you want to know more I suggest google 'what is a database relationship' and 'what is a query join'

what difference between table relationship and query relationship

Thread Tools

what difference between table relationship and query relationship

Similar Threads

Relationship linking for Laboratory procurement database, many-to-many relationship help

Need to add a single record to a table using an sppend query with a one to many relationship

Query that will keep the one to many relationship from the orginal table

Query results showing table relationship

relationship between query and table

Posting Permissions