1
  • Need urgent help

    What is query to map data by combining multiple columns in different table I have two tables named table 1 and table 2 respt.. In table 1 is as shown below User Role AP.A AP.B AP.C AP.D High Low Medium Sanket Admin AP.A AP.B AP.D Abhi Man AP.B AP.C Sank Emp AP.A AP.C AP.D And I have one more table...

    sanketkolge1010 pointsBadges:
  • Mulitple Selects

    Trying to isolate specific entries from a table based on Production Code: (Select (P.EntryDate) From Production P Full JOIN ProductionJobNumber PJ on P.Code = PJ.ProductionCode Where P.ProcessCode = 1080 and PJ.JobNumber = OH.JobNumber) as OkToPlate, (Select (P.EntryDate) From Production P FULL...

    jsmithuni0110 pointsBadges:
  • Count IIF Statement?

    In the design of a query, I noticed that under the tab "Group By", there are only a few types of commands to make calculations. For example, the commands include Sum, Avg, Min, Max, Count, StDev, Var, First, Last, Expression, Where. Is it possible to have a special command? I'd like to use...

    Twj21025 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following