Sql Query


i have two table name ‘routing’ and ‘destination’ .i want that the two digit no of destination as 91,92,93 to matched to routing table and not repeated and give result unique.How can we manage it by query please guide me .

thank You


DISTINCT a.destination


routing a RIGHT JOIN

destination b ON a.destination =b.destination

ORDER BY a.destination

If not working, paste the table structure