Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re: database strategy

by Cine (Friar)
on Aug 03, 2002 at 01:12 UTC ( #187262=note: print w/replies, xml ) Need Help??


in reply to database strategy

I would suggest that you do it via two sql's
SELECT * FROM table a,table b WHERE a.id = b.id AND a.id IS NOT NULL A +ND a.id != ''; and SELECT * FROM table a,table b WHERE a.first_name = b.first_name AND a. +last_name = b.last_name AND (a.id IS NULL or a.id = '') AND (b.id IS NULL or b.id = '');


T I M T O W T D I

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://187262]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (4)
As of 2023-02-07 22:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I prefer not to run the latest version of Perl because:







    Results (40 votes). Check out past polls.

    Notices?