Selecting from 3 tables.
From: folke (folke_at_discussions.microsoft.com)
Date: 09/29/04
- Next message: Steve Thompson: "Re: Login failed for user '(null)'"
- Previous message: Bil: "Re: Login failed for user '(null)'"
- Next in thread: Mike Epprecht (SQL MVP): "RE: Selecting from 3 tables."
- Reply: Mike Epprecht (SQL MVP): "RE: Selecting from 3 tables."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 29 Sep 2004 06:59:03 -0700
I have 3 tables
tab1 with columns sname, fpath
tab2 with cloumns pname, fpath
tab3 with column pname
I like to join tab1 and tab2 on fpath and get all rows that do NOT have
tab2.pname = tab3.pname
A query for that?
-- Folke
- Next message: Steve Thompson: "Re: Login failed for user '(null)'"
- Previous message: Bil: "Re: Login failed for user '(null)'"
- Next in thread: Mike Epprecht (SQL MVP): "RE: Selecting from 3 tables."
- Reply: Mike Epprecht (SQL MVP): "RE: Selecting from 3 tables."
- Messages sorted by: [ date ] [ thread ]
