Almost got a self join working the way I want, but not quite...
I've got a table of Office Branches. Some of them are MAIN BRANCHES (value
"main" under "sub_branch" in table).
Others are SUB BRANCHES and would have the branch_ID of the main branch
listed in the "sub_branch" cell.
So, I need a self join to get this to work, correct? Can't get the syntax
just right....
Table: BRANCHES
---------------
ID
branch_name
branch_ID
sub_branch
Return results like
------------------
Main Branch 1
SubBranch 1
SubBranch 2
Main Branch 2
Main Branch 3
SubBranch 3
Some assistance please?
Thanks....
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
