basic SELECT statements

[matthew_moore_2]

How can I write a SQL statement that returns all columns in table A, one that returns all columns in table A where inv is 1, and a statement that returns all columns from table A and B where inv is equal?

I don't know that much about writing statements 

[ngreenwood6]

You would need to make 2 different queries and then figure out which one you need.

 

if($inv == 1)

{

$query = "SELECT * FROM table WHERE a='value'";

}

else

{

$query = "SELECT * FROM table WHERE a='value' AND b='value'";

}

[matthew_moore_2]

So just modify this statement to reflect the other two?

[ngreenwood6]

That was just a basic example of how you can accomplish what you are trying to accomplish but yeah basically you can just modify it for your needs substituting what you need where you need it. once you get something down and have a problem getting it to work come back and post.

[fenway]

How can I write a SQL statement that returns all columns in table A, one that returns all columns in table A where inv is 1, and a statement that returns all columns from table A and B where inv is equal?

I have no idea what you're getting at.