All pastes #168127 Raw Edit

Untitled

public sql v1 · immutable
·published 2006-09-12 18:43 UTC
rendered paste body
select computers.ip_addr,site_gad_trans.gadid,CONCAT(computers.bp_family,'-',computers.bp_version,'.',computers.bp_version_minor,'.',computers.bp_version_localization) as buildid from computers LEFT JOIN (computers, site_gad_trans, roles) ON (site_gad_trans.siteid = computers.bp_family AND roles.family = computers.role) WHERE computers.ip_addr = '10.0.13.9' AND computers.site != 'noanswer';ERROR 1066 (42000): Not unique table/alias: 'computers'