Database Admin. :
Student Freelance Forum For Work Experience Builders' (CertificationPoint)
Query Help - SQL
Posted by:
adcertpoint
(Moderator)
Date: July 02, 2017 01:29AM
Trying to query to display only ROWS with a YES value & list what PC# has a yes value. Not working & ask for your help, please.
SQL syntax:
<code>
--------------------------------
Select from * FROM tbl_PC
WHERE Function='Yes'
--------------------------------
</code>
Output shows this - not what I wanted
Function PC1 PC2 PC3 PC4 PC5 PC6
copy No Yes No Yes No Yes
paste No Yes No Yes No Yes No
delete No No Yes Yes No Yes
backup Yes Yes No No Yes No
edit No Yes Yes No Yes Yes
new No No No Yes No No
SQL syntax:
<code>
--------------------------------
Select from * FROM tbl_PC
WHERE Function='Yes'
--------------------------------
</code>
Output shows this - not what I wanted
Function PC1 PC2 PC3 PC4 PC5 PC6
copy No Yes No Yes No Yes
paste No Yes No Yes No Yes No
delete No No Yes Yes No Yes
backup Yes Yes No No Yes No
edit No Yes Yes No Yes Yes
new No No No Yes No No
Sorry, only registered users may post in this forum.