quick question

Results 1 to 2 of 2

Thread: quick question

  1. #1
    Join Date
    Dec 1969

    Default quick question

    I want to only select distinct categories from a database, I am using this SQL statement.<BR><BR>SQL = "SELECT * FROM businesses"<BR><BR>I have forgotten the correct syntax, thanks.

  2. #2
    Richard A. Lowe Guest

    Default RE: quick question

    SELECT DISTINCT categories FROM businesses<BR><BR>What would be better, though, is if you had a categories table (normalized data) so you could just select all from there.<BR><BR>Richard

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts