Join table with empty data

[cesarcesar]

Hello,

I'm a novice, and am having issues get a JOIN to work properly. The following code is correct for pulling field values that HAVE a value, but when a field i am requesting has a value like Null, Space, or just empty, the whole query comes back empty.

It was suggested i use TRIM in my call, but i'm not exactly sure how to use properly.

As far as each table, the fields that are empty are set to ALLOW NULL. Thanks for the help.

[code=php:0]
Select
company.company_name,
company.company_username,
company.company_clients_served,
company.company_status,
note.note_text,
address.address_street1,
address.address_street2,
address.address_zip,
address.address_zip_ext,
county.county_id,
city.city_name,
taxes_states.state_id,
email.email_address,
url.url_path,
url.url_name,
company_type.company_type_id
From
company
Inner Join note ON company.note_id = note.note_id
,
address
Inner Join connector_address ON company.company_id = connector_address.ref_id AND connector_address.address_id = address.address_id
Inner Join county ON address.county_id = county.county_id
Inner Join city ON address.city_id = city.city_id
Inner Join taxes_states ON address.state_id = taxes_states.state_id
Inner Join connector_email ON company.company_id = connector_email.ref_id
Inner Join email ON connector_email.email_id = email.email_id
Inner Join connector_url ON company.company_id = connector_url.ref_id
Inner Join url ON connector_url.url_id = url.url_id
,
company_type
Inner Join connector_company ON company_type.company_type_id = connector_company.company_type AND company.company_id = connector_company.company_id
Where company.company_id = '15'
[/code]

[magic2goodil]

fix your code layout and repost that please...it's too much of a mess to understand

also around each field i suggest `` those are above the tab key..and around any values you are putting behind where =, put ' ' around them..

[cesarcesar]

my code is not readable? Each select is on a separate line, each join is on a separate line. i thought this would be the most easiest to read.

Do i put `` around statements like, [code]company.company_id = `connector_url.ref_id`[/code]? Im sure this is not the fix though. I have not used `` in my code (noobie error, i will change), and code has worked fine.

[magic2goodil]

it would be like this
[code]select `company.company_id` from company where `company.note_id` = 'value'[/code]

not sure this is one for me to answer though because i am not sure what Inner JOIN does