SQL Statement for more than one type of code in the same column -

-

i have basic query selecting 1 table , joining table. on second table using filter on column exclude records don't want.

the first table basic, things name, id, address, etc. contains no duplicates. second table (product table) more this:

    id      code    desc            desc2     -----------------------------------------     94      pg      county code     sydney, ne     95      pg      county code     monticello, ut       96      pg      county code     vernal, ut       97      pg      county code     other, out of state             pg      county code     no data      1       ps      race code       spanish american         2       ps      race code       other - white        3       ps      race code       black        4       ps      race code       american indian

and select looks this:

select a.*, b.desc  custtable  inner join prod_table b    on a.id = b.id  b.code = 'pg'

i have need records prod_table code = 'ps'.

is there way in 1 query or need make table 'ps' records , query that?

edit: sorry being confusing, trying simplify things made worse. edited post actual data table, maybe help.

select a.*, b.desc  custtable  inner join prod_table b  on a.id = b.id  b.code = 'pg' or b.code = 'ps'

or

select a.*, b.desc  custtable  inner join prod_table b  on a.id = b.id  b.code in('pg','ps')

Comments

Post a Comment

Popular posts from this blog

c++ - Linked List error when inserting for the last time -

-
so have part of code here this loop 5 times (max = 5) insert word link list. for ( int = 0 ; < max ; i++ ) { string alphabet = g->returnalphabets(); l[i]->addwords(alphabet[i]); } and have insert word part here string line; fstream myfile ("words.txt"); while (!myfile.eof()) { getline(myfile,line); if ( alphabet == line[0] ) { listnode *newnode = new listnode; if ( head == null ) { newnode->item = alphabet; newnode->next = null; head = newnode; } else { newnode->item = line; prev = cur; prev->next = newnode; } cur = newnode; } } myfile.close(); my problem gives me error on last loop. meaning on max = 4, insert node. rest of loop fine. when decrease max 4 meaning loop 4 times, program error-free when program loops 5 times gives error. anyone can poin...
Read more

java - activate/deactivate sonar maven plugin by profile? -

-
i use sonar plugin executes if activated in maven profile. sonar runs on every compile. the problem build fail other team members not have sonar application installed locally. pom.xml checked in team members same copy including sonar configuration, don't want them modify purpose of disabling sonar (they might inadvertently check modified copy in). please advise how configure maven (.m2/settings.xml) and/or pom.xml sonar feature can enabled/disabled local profile. here sonar configuration in each project's pom.xml: <plugin> <groupid>org.codehaus.mojo</groupid> <artifactid>sonar-maven-plugin</artifactid> <version>1.0</version> <executions> <execution> <id>make-sonar</id> <phase>compile</phase> <goals> <goal>sonar</goal> </goals> </execution> </executions> ...
Read more

java - What is the difference between String. and String.this. ? -

-
this question has answer here: meaning of .this , .class in java 2 answers i'll straight point. im still learning bit of syntax , want know difference between code is code a: public class buttonz extends jbutton{ public buttonz(){ settext(new string(string.valueof(i))); } } please ignore fact i undeclared, not lost. code b: public class buttonz extends jbutton{ public buttonz(){ settext(new string(string.this.charat(i))); } } what don't yet understand difference in typing string.this , string. i under assumption when use dot operator on class accessing it's static methods(and/or variables if they're not hidden). i have studied little bit , have concluded when using string. accessing string static methods.. when using string.this. i'm accessing methods class buttonz extendi...
Read more