How can i join two query table based on common column ( host), but i want to display all columns from 1st table but just 1 column ( Incident column) from 2nd table??
Query 1 displays ( Host, Time, Eventcode, Message)
Query 2 displays ( subject, Host, Incident)
i want to all match hosts in both column and based on that join the querys to display ( Host, Time, Eventcode, Message, incident)
This worked but it is not displaying Host from query 1 even if it doesnt find any host in query 2??
my requirment is to match host but also display all output fro. Query 1??