Two JOINs from the same table name?

[coldfission]

SELECT orders.orders_id AS ID, last_modified AS modified, customers_city AS city, customers_state AS state, customers_country AS country, value AS total
FROM orders
LEFT JOIN orders_total
ON orders.orders_id=orders_total.orders_id
WHERE orders_status=3 AND class='ot_total'
ORDER BY last_modified DESC
LIMIT 0,20

 

that is my working statement, but now i need to do this too:

 

LEFT JOIN orders_total
ON orders.orders_id=orders_total.orders_id
WHERE orders_status=3 AND class='ot_shipping'

Difference: class='ot_shipping'

 

They are coming from the same table. I need the 'Title' from ot_shipping, but not the 'Title' from ot_total.

 

How would i do this?

 

thanks

[Wildbug]

If you want to JOIN the same table more than once you need to use an alias.

 

...FROM table AS t1 JOIN table AS t2 ON t1.id=t2.id...

 

Can you do this though?

...WHERE orders_status=3 AND (class='ot_shipping' OR class='ot_total')....