SQL query question

Yurmasyurda

It's ok I found the answer, delete if you please.

Evil Phil

I was just about to answer too :rolleyes:

leeroybrown

It would have been nice if you left the question up and posted the solution you found. That way everyone benefits ...

Yurmasyurda

Too lazy to re-write the question but the gist was how to combine a query command in one statement, it was a bit complicated but roughly what I was doing was...


select * from SMSSend where senddate='1900-01-01'
select * from SMSSend where SMSTo='NULL'
select * from SMSSend where SMSSender='New'


what I should've done was...

select * from SMSSend where senddate='1900-01-01'
and SMSTo <> 'NULL'
and SMSSender <> 'New'

DeVore

That is a better way alright but occasionally you DO need to stitch together two similar recordsets.

select field1, field2 from <tablename> where <criteria>
UNION
select field1a, field2a from <table2name> where <criteria2>

Now so long as field1 and field2 are similar to field1a and field2a and there is the same number of coumns in both recordsets then you can use the UNION command to make one big recordset out of them.

I think there may even be relaxations recently about the amount the two recordsets have to match but thats an RDBMS-specific problem.

DeV.

Typedef

Certainly selecting * is bad. Select specific fields, this is faster.

Much like using inline sql where you can instead of using cursors.

bump.