Re: [PHP] Which query is more correct?

2009-11-23 Thread LAMP
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 wh

Re: [PHP] Which query is more correct?

2009-11-22 Thread LinuxManMikeC
On Sat, Nov 21, 2009 at 2:52 PM, Nathan Rixham 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 >>> ToBeRecleared.tbrc

Re: [PHP] Which query is more correct?

2009-11-21 Thread Nathan Rixham
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.

Re: [PHP] Which query is more correct?

2009-11-20 Thread Rick Pasotto
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 > wher

Re: [PHP] Which query is more correct?

2009-11-20 Thread Ashley Sheridan
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.r