Simple Query

[ryakubisin]

I need to write a progress sql statement. It should be simple. I will use it in Crystal reports. I am not familiar with formatting for progress.

This is how it is written for Access. How would it be changed for progress?
SELECT PUB_blq.[Master-quote-set], PUB_blq.[Master-quote-type], PUB_blq.[Item-code]
FROM PUB_blq
WHERE (((PUB_blq.[Master-quote-set])=2) AND ((PUB_blq.[Master-quote-type])=1));

 

[tamhas]

You might try the SQL forum.

The query should be virtually identical except that you tend to have to prefix with "PUB." to identify the owner and use double quote rather than bracket to enclose table and field names with illegal characters.