Rick Pasotto wrote:
On Fri, Nov 20, 2009 at 04:41:58PM -0600, LAMP wrote:
Hi,
I need to pull all records from the table Registrants they are NOT
in the table ToBeRecleared
Registrants.Reg_ID is PK
ToBeRecleared.tbrc_Reg_ID is PK
Which query is more correct?
SELECT r.*
FROM registrants r
On Sat, Nov 21, 2009 at 2:52 PM, Nathan Rixham nrix...@gmail.com wrote:
Rick Pasotto wrote:
On Fri, Nov 20, 2009 at 04:41:58PM -0600, LAMP wrote:
Hi,
I need to pull all records from the table Registrants they are NOT
in the table ToBeRecleared
Registrants.Reg_ID is PK
Rick Pasotto wrote:
On Fri, Nov 20, 2009 at 04:41:58PM -0600, LAMP wrote:
Hi,
I need to pull all records from the table Registrants they are NOT
in the table ToBeRecleared
Registrants.Reg_ID is PK
ToBeRecleared.tbrc_Reg_ID is PK
Which query is more correct?
SELECT r.*
FROM registrants
Hi,
I need to pull all records from the table Registrants they are NOT in
the table ToBeRecleared
Registrants.Reg_ID is PK
ToBeRecleared.tbrc_Reg_ID is PK
Which query is more correct?
SELECT r.*
FROM registrants r
where r.reg_status=1 AND r.reg_id NOT IN (SELECT tbrc_reg_id FROM
On Fri, 2009-11-20 at 16:41 -0600, LAMP wrote:
Hi,
I need to pull all records from the table Registrants they are NOT in
the table ToBeRecleared
Registrants.Reg_ID is PK
ToBeRecleared.tbrc_Reg_ID is PK
Which query is more correct?
SELECT r.*
FROM registrants r
where r.reg_status=1
On Fri, Nov 20, 2009 at 04:41:58PM -0600, LAMP wrote:
Hi,
I need to pull all records from the table Registrants they are NOT
in the table ToBeRecleared
Registrants.Reg_ID is PK
ToBeRecleared.tbrc_Reg_ID is PK
Which query is more correct?
SELECT r.*
FROM registrants r
where
6 matches
Mail list logo