Login or Sign Up
- Logging in...
  
  Remember me
  
  Or
  
  Sign Up
  
  Forgot password or user name?
- Log in with

Search in titles only Search in posts by mokamalx only

Advanced Search

Forums
BYTES
Product Launch
Updates
Developer Toolkit

Today's Posts
Member List
Calendar

Home
mokamalx

User Profile

Collapse

Profile Sidebar

Collapse

mokamalx

Last Activity: Jun 25 '10, 06:53 PM

Joined: Jun 18 '10

Location:

Subscriptions1
Subscribers0

Activities
About
Media
Subscribed

Time

All Time Today Last Week Last Month
Show

All Discussions only Photos only Videos only Links only Polls only Events only
Source

All mokamalx only Visitor Messages Only Advanced

Filtered by:

new posts

mokamalx replied to Query to return customers with more than one type...

in SQL Server

Jun 25 '10, 06:53 PM
What I have so far...

select cst_id,
pht_code
cph_pht_key
from co_phone_type (NOLOCK)
LEFT JOIN co_customer (nolock) on pht_key=cst_key
LEFT JOIN co_customer_x_p hone (nolock) on cph_key=cph_pht _key
where pht_code = 'Billing'

Thanks for any help.

Mk

See more | Go to post
Leave a comment:
mokamalx started a topic Query to return customers with more than one type...

in SQL Server

Jun 18 '10, 05:42 PM
Query to return customers with more than one type...

I'm trying to create a query that returns a list of customers that have more than one type of phone number (cell, home, business) in their "phone_type " drop down column. Any help would be appreciated.

See more | Go to post

No activity results to display

Show More

Bytes
Help
Contact Us
Privacy
Terms of Service
Go to top

All times are GMT. This page was generated at 1 minute ago.

Working...

👍

👎

☕