Hi all
Got a tricky SQL query.
One table
tblTemp
ID - Factory - Articlenr
1 - 22 - CP001
2 - 35 - CP001
3 - 35 - CS001
4 - 35 - BA001
5 - 23 - CP001
6 - 35 - CS001
7 - 22 - CP001
I need to select all from Factory 35
And in that query all Articlenr that start with CP or CS
The query would show
ID - Factory - Articlenr
2 - 35 - CP001
3 - 35 - CS001
6 - 35 - CS001
Any pointers would be most appreciative
Regards
Jon
jr*@telia.com