1. Home
  2. Point-Of-Sale Software
  3. SQL statement help

SQL statement help

I would like to add this to the following statement: inactive = no

SELECT * FROM Item WHERE HQID = 0

Thanks in advance lax guy

Reply to
lax guy
Loading thread data ...

The script would be changed to SELECT * FROM Item WHERE (HQID = 0) AND (Inactive = 0)

Reply to
rsakry

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.