Maroti, this would be a heck of a lot easier to solve if the query was nicely formatted, as follows:

[font="Courier New"]

FROM maintSubStrategySecurityType

RIGHT JOIN tblBlackrockPositionsByFund AS Positions

   ON maintSubStrategySecurityType.[Sub...

Can you provide the necessary logic for one join to be selected? One option you could use is to LEFT JOIN for each of the three possible joins and pick...

You're welcome ChrisT, thanks for the feedback.

Cheers

ChrisM

Use LIKE in the join:

[font="Courier New"]

SELECT a.zipcode, z.zipcode

FROM AgentAddresses a

LEFT JOIN ZipCodes z ON a.zipcode LIKE z.zipcode+'%'[/font]

Cheers

ChrisM

What client software are you using to display the date to the user? Is the default display of datetime provided by this client (and using regional settings) inappropriate for your...

Sudarsan, it's difficult to tell exactly what you mean. One interpretation of your requirements is as follows:

You have dates in an unknown format. These dates are in table columns.

You want...

UPDATE c SET hazard_info = h.hazard_phrase

FROM compound c

INNER JOIN hazard h on h.compound_id = c.compound_id

Cheers

ChrisM

Jeff Moden (8/19/2008)

---

Chris Morris (8/19/2008)

---

Really nice to read, Jeff, and absolutely spot on.

I've had to do pivots in the last couple of weeks, with an unknown number of output (transposed)...

Really nice to read, Jeff, and absolutely spot on.

I've had to do pivots in the last couple of weeks, with an unknown number of output (transposed) columns with unknown names,...

This one runs nightly, sometimes with irritating sound effects.

Sergiy (8/7/2008)

---

What is your default...

Gosh Jeremy :blush: thanks!

Be afraid...be very afraid...

Nah Chris I'm picking the easy ones, same as you 😛 😀

VB (8/7/2008)

---

thanks for the reply, however this wont achieve my goal, becuase if the "key" is not null i want a inner join on the tables if not jus the...

Thanks for pointing this out Chris, one...