Page 1 of 1

Two SQL statement in one Query...

Posted: Fri Sep 25, 2009 7:57 pm
by azri_bech
Anyone can help to resolve my problem.

How to create two sql statement in one query.
i want to SELECT * FROM tablename1 and another one SELECT DISTINCT date_posted FROM tablename1

Thanks.

Re: Two SQL statement in one Query...

Posted: Fri Sep 25, 2009 8:01 pm
by jackpf
Union?

Re: Two SQL statement in one Query...

Posted: Fri Sep 25, 2009 8:03 pm
by azri_bech
yes