var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Lookup and match
On the look for a little help again
I have two tables
So far the main table contains IP address and there MACS and a PRINTER QUEUE name
one IP address can be assigned to more than one queue
Finally the on the mactables: I have a list of mac address assinged to ports
I have managed to run a query at the moment where MAC mataches on both tables, but after the match I want to be able to copy the SWITCH and PORT number over to the main form.
Any ideas on how to do this?
Hope this helps,
UPDATE main INNER JOIN mactables On main.mac = mactables.mac; SET main.PORT = mactables.PORT, main.SWITCH = mactables.SWITCH;