Hi
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
Hi
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
SELECT
DISTINCT a.destination
FROM
routing a RIGHT JOIN
destination b ON a.destination =b.destination
ORDER BY a.destination
If not working, paste the table structure