sql-variables

CodeCharge Studio

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

sql-variables

Author

Message

prom-q

Posts: 1

Posted: 05/18/2009, 3:49 AM

a table products_origin which has columns productid,origin

select productid from products_origin where origin like' us'

say origin column has three entries :'us', 'at', 'jk' now i have to make one query to get productid for al three entries of origin...

ReneS

Posts: 225

Posted: 05/18/2009, 12:35 PM

Hi,

I think I don't understand the question, but the way i read it is:
you could just leave out the "where" clause....

Rene

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login