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
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
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.
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
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
5 matches
Mail list logo