Sorting data using MS Query

[daggers]

Hi,

I am currently using the GUI on Query to sort data from a server. However, I am having a problem trying to sort the following..(===) denotes link

Table 1 Table 2
product_num======product_num
type (A,B) data (x,y,z)

Currently, I am sorting the data according to the following criteria:

type data
='A' and ='z'

However, is it possible to create a SQL statement which says "Display type A if it has data z, IF type B has data x"
?

Thanks
Ross